Data Warehouse Security through Conceptual Models

A key challenge for data warehouse security is how to manage the entire system coherently – from sources and their export tables, to warehouse stored tables (conventional and cubes) and views defined over the warehouse. Permissions on the warehouse must satisfy the restrictions of the data owners, and be updated quickly as those local concerns evolve. Yet the system cannot demand extensive administrator time, since there are too few people with both technical skills to understand derivation logic, and business skills to balance security versus accessibility. Security aspects should be considered in the design phase of the data warehouse to better match the security requirements and to avoid later fundamental,cost-intensive adaptations. For the identification of security requirements legal, audit, network and other issues have to be considered